package pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class WlOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public WlOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIsNull() {
            addCriterion("orderType is null");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIsNotNull() {
            addCriterion("orderType is not null");
            return (Criteria) this;
        }

        public Criteria andOrdertypeEqualTo(Integer value) {
            addCriterion("orderType =", value, "ordertype");
            return (Criteria) this;
        }

        public Criteria andOrdertypeNotEqualTo(Integer value) {
            addCriterion("orderType <>", value, "ordertype");
            return (Criteria) this;
        }

        public Criteria andOrdertypeGreaterThan(Integer value) {
            addCriterion("orderType >", value, "ordertype");
            return (Criteria) this;
        }

        public Criteria andOrdertypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("orderType >=", value, "ordertype");
            return (Criteria) this;
        }

        public Criteria andOrdertypeLessThan(Integer value) {
            addCriterion("orderType <", value, "ordertype");
            return (Criteria) this;
        }

        public Criteria andOrdertypeLessThanOrEqualTo(Integer value) {
            addCriterion("orderType <=", value, "ordertype");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIn(List<Integer> values) {
            addCriterion("orderType in", values, "ordertype");
            return (Criteria) this;
        }

        public Criteria andOrdertypeNotIn(List<Integer> values) {
            addCriterion("orderType not in", values, "ordertype");
            return (Criteria) this;
        }

        public Criteria andOrdertypeBetween(Integer value1, Integer value2) {
            addCriterion("orderType between", value1, value2, "ordertype");
            return (Criteria) this;
        }

        public Criteria andOrdertypeNotBetween(Integer value1, Integer value2) {
            addCriterion("orderType not between", value1, value2, "ordertype");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNull() {
            addCriterion("orderNo is null");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNotNull() {
            addCriterion("orderNo is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernoEqualTo(String value) {
            addCriterion("orderNo =", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotEqualTo(String value) {
            addCriterion("orderNo <>", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThan(String value) {
            addCriterion("orderNo >", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThanOrEqualTo(String value) {
            addCriterion("orderNo >=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThan(String value) {
            addCriterion("orderNo <", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThanOrEqualTo(String value) {
            addCriterion("orderNo <=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLike(String value) {
            addCriterion("orderNo like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotLike(String value) {
            addCriterion("orderNo not like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoIn(List<String> values) {
            addCriterion("orderNo in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotIn(List<String> values) {
            addCriterion("orderNo not in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoBetween(String value1, String value2) {
            addCriterion("orderNo between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotBetween(String value1, String value2) {
            addCriterion("orderNo not between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andChannelIsNull() {
            addCriterion("channel is null");
            return (Criteria) this;
        }

        public Criteria andChannelIsNotNull() {
            addCriterion("channel is not null");
            return (Criteria) this;
        }

        public Criteria andChannelEqualTo(Integer value) {
            addCriterion("channel =", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotEqualTo(Integer value) {
            addCriterion("channel <>", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelGreaterThan(Integer value) {
            addCriterion("channel >", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelGreaterThanOrEqualTo(Integer value) {
            addCriterion("channel >=", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelLessThan(Integer value) {
            addCriterion("channel <", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelLessThanOrEqualTo(Integer value) {
            addCriterion("channel <=", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelIn(List<Integer> values) {
            addCriterion("channel in", values, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotIn(List<Integer> values) {
            addCriterion("channel not in", values, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelBetween(Integer value1, Integer value2) {
            addCriterion("channel between", value1, value2, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotBetween(Integer value1, Integer value2) {
            addCriterion("channel not between", value1, value2, "channel");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("userId is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("userId is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("userId =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("userId <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("userId >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("userId >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("userId <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("userId <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("userId like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("userId not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("userId in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("userId not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("userId between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("userId not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridIsNull() {
            addCriterion("groupBuyUserId is null");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridIsNotNull() {
            addCriterion("groupBuyUserId is not null");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridEqualTo(String value) {
            addCriterion("groupBuyUserId =", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridNotEqualTo(String value) {
            addCriterion("groupBuyUserId <>", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridGreaterThan(String value) {
            addCriterion("groupBuyUserId >", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridGreaterThanOrEqualTo(String value) {
            addCriterion("groupBuyUserId >=", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridLessThan(String value) {
            addCriterion("groupBuyUserId <", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridLessThanOrEqualTo(String value) {
            addCriterion("groupBuyUserId <=", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridLike(String value) {
            addCriterion("groupBuyUserId like", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridNotLike(String value) {
            addCriterion("groupBuyUserId not like", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridIn(List<String> values) {
            addCriterion("groupBuyUserId in", values, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridNotIn(List<String> values) {
            addCriterion("groupBuyUserId not in", values, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridBetween(String value1, String value2) {
            addCriterion("groupBuyUserId between", value1, value2, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridNotBetween(String value1, String value2) {
            addCriterion("groupBuyUserId not between", value1, value2, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andTokenIsNull() {
            addCriterion("token is null");
            return (Criteria) this;
        }

        public Criteria andTokenIsNotNull() {
            addCriterion("token is not null");
            return (Criteria) this;
        }

        public Criteria andTokenEqualTo(String value) {
            addCriterion("token =", value, "token");
            return (Criteria) this;
        }

        public Criteria andTokenNotEqualTo(String value) {
            addCriterion("token <>", value, "token");
            return (Criteria) this;
        }

        public Criteria andTokenGreaterThan(String value) {
            addCriterion("token >", value, "token");
            return (Criteria) this;
        }

        public Criteria andTokenGreaterThanOrEqualTo(String value) {
            addCriterion("token >=", value, "token");
            return (Criteria) this;
        }

        public Criteria andTokenLessThan(String value) {
            addCriterion("token <", value, "token");
            return (Criteria) this;
        }

        public Criteria andTokenLessThanOrEqualTo(String value) {
            addCriterion("token <=", value, "token");
            return (Criteria) this;
        }

        public Criteria andTokenLike(String value) {
            addCriterion("token like", value, "token");
            return (Criteria) this;
        }

        public Criteria andTokenNotLike(String value) {
            addCriterion("token not like", value, "token");
            return (Criteria) this;
        }

        public Criteria andTokenIn(List<String> values) {
            addCriterion("token in", values, "token");
            return (Criteria) this;
        }

        public Criteria andTokenNotIn(List<String> values) {
            addCriterion("token not in", values, "token");
            return (Criteria) this;
        }

        public Criteria andTokenBetween(String value1, String value2) {
            addCriterion("token between", value1, value2, "token");
            return (Criteria) this;
        }

        public Criteria andTokenNotBetween(String value1, String value2) {
            addCriterion("token not between", value1, value2, "token");
            return (Criteria) this;
        }

        public Criteria andMastermoneyIsNull() {
            addCriterion("masterMoney is null");
            return (Criteria) this;
        }

        public Criteria andMastermoneyIsNotNull() {
            addCriterion("masterMoney is not null");
            return (Criteria) this;
        }

        public Criteria andMastermoneyEqualTo(Integer value) {
            addCriterion("masterMoney =", value, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyNotEqualTo(Integer value) {
            addCriterion("masterMoney <>", value, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyGreaterThan(Integer value) {
            addCriterion("masterMoney >", value, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyGreaterThanOrEqualTo(Integer value) {
            addCriterion("masterMoney >=", value, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyLessThan(Integer value) {
            addCriterion("masterMoney <", value, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyLessThanOrEqualTo(Integer value) {
            addCriterion("masterMoney <=", value, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyIn(List<Integer> values) {
            addCriterion("masterMoney in", values, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyNotIn(List<Integer> values) {
            addCriterion("masterMoney not in", values, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyBetween(Integer value1, Integer value2) {
            addCriterion("masterMoney between", value1, value2, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyNotBetween(Integer value1, Integer value2) {
            addCriterion("masterMoney not between", value1, value2, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andOrdermoneyIsNull() {
            addCriterion("orderMoney is null");
            return (Criteria) this;
        }

        public Criteria andOrdermoneyIsNotNull() {
            addCriterion("orderMoney is not null");
            return (Criteria) this;
        }

        public Criteria andOrdermoneyEqualTo(Integer value) {
            addCriterion("orderMoney =", value, "ordermoney");
            return (Criteria) this;
        }

        public Criteria andOrdermoneyNotEqualTo(Integer value) {
            addCriterion("orderMoney <>", value, "ordermoney");
            return (Criteria) this;
        }

        public Criteria andOrdermoneyGreaterThan(Integer value) {
            addCriterion("orderMoney >", value, "ordermoney");
            return (Criteria) this;
        }

        public Criteria andOrdermoneyGreaterThanOrEqualTo(Integer value) {
            addCriterion("orderMoney >=", value, "ordermoney");
            return (Criteria) this;
        }

        public Criteria andOrdermoneyLessThan(Integer value) {
            addCriterion("orderMoney <", value, "ordermoney");
            return (Criteria) this;
        }

        public Criteria andOrdermoneyLessThanOrEqualTo(Integer value) {
            addCriterion("orderMoney <=", value, "ordermoney");
            return (Criteria) this;
        }

        public Criteria andOrdermoneyIn(List<Integer> values) {
            addCriterion("orderMoney in", values, "ordermoney");
            return (Criteria) this;
        }

        public Criteria andOrdermoneyNotIn(List<Integer> values) {
            addCriterion("orderMoney not in", values, "ordermoney");
            return (Criteria) this;
        }

        public Criteria andOrdermoneyBetween(Integer value1, Integer value2) {
            addCriterion("orderMoney between", value1, value2, "ordermoney");
            return (Criteria) this;
        }

        public Criteria andOrdermoneyNotBetween(Integer value1, Integer value2) {
            addCriterion("orderMoney not between", value1, value2, "ordermoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyIsNull() {
            addCriterion("discountMoney is null");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyIsNotNull() {
            addCriterion("discountMoney is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyEqualTo(Integer value) {
            addCriterion("discountMoney =", value, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyNotEqualTo(Integer value) {
            addCriterion("discountMoney <>", value, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyGreaterThan(Integer value) {
            addCriterion("discountMoney >", value, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountMoney >=", value, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyLessThan(Integer value) {
            addCriterion("discountMoney <", value, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyLessThanOrEqualTo(Integer value) {
            addCriterion("discountMoney <=", value, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyIn(List<Integer> values) {
            addCriterion("discountMoney in", values, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyNotIn(List<Integer> values) {
            addCriterion("discountMoney not in", values, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyBetween(Integer value1, Integer value2) {
            addCriterion("discountMoney between", value1, value2, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyNotBetween(Integer value1, Integer value2) {
            addCriterion("discountMoney not between", value1, value2, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andFreightIsNull() {
            addCriterion("freight is null");
            return (Criteria) this;
        }

        public Criteria andFreightIsNotNull() {
            addCriterion("freight is not null");
            return (Criteria) this;
        }

        public Criteria andFreightEqualTo(Integer value) {
            addCriterion("freight =", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotEqualTo(Integer value) {
            addCriterion("freight <>", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThan(Integer value) {
            addCriterion("freight >", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThanOrEqualTo(Integer value) {
            addCriterion("freight >=", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightLessThan(Integer value) {
            addCriterion("freight <", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightLessThanOrEqualTo(Integer value) {
            addCriterion("freight <=", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightIn(List<Integer> values) {
            addCriterion("freight in", values, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotIn(List<Integer> values) {
            addCriterion("freight not in", values, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightBetween(Integer value1, Integer value2) {
            addCriterion("freight between", value1, value2, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotBetween(Integer value1, Integer value2) {
            addCriterion("freight not between", value1, value2, "freight");
            return (Criteria) this;
        }

        public Criteria andFreefreightIsNull() {
            addCriterion("freeFreight is null");
            return (Criteria) this;
        }

        public Criteria andFreefreightIsNotNull() {
            addCriterion("freeFreight is not null");
            return (Criteria) this;
        }

        public Criteria andFreefreightEqualTo(Integer value) {
            addCriterion("freeFreight =", value, "freefreight");
            return (Criteria) this;
        }

        public Criteria andFreefreightNotEqualTo(Integer value) {
            addCriterion("freeFreight <>", value, "freefreight");
            return (Criteria) this;
        }

        public Criteria andFreefreightGreaterThan(Integer value) {
            addCriterion("freeFreight >", value, "freefreight");
            return (Criteria) this;
        }

        public Criteria andFreefreightGreaterThanOrEqualTo(Integer value) {
            addCriterion("freeFreight >=", value, "freefreight");
            return (Criteria) this;
        }

        public Criteria andFreefreightLessThan(Integer value) {
            addCriterion("freeFreight <", value, "freefreight");
            return (Criteria) this;
        }

        public Criteria andFreefreightLessThanOrEqualTo(Integer value) {
            addCriterion("freeFreight <=", value, "freefreight");
            return (Criteria) this;
        }

        public Criteria andFreefreightIn(List<Integer> values) {
            addCriterion("freeFreight in", values, "freefreight");
            return (Criteria) this;
        }

        public Criteria andFreefreightNotIn(List<Integer> values) {
            addCriterion("freeFreight not in", values, "freefreight");
            return (Criteria) this;
        }

        public Criteria andFreefreightBetween(Integer value1, Integer value2) {
            addCriterion("freeFreight between", value1, value2, "freefreight");
            return (Criteria) this;
        }

        public Criteria andFreefreightNotBetween(Integer value1, Integer value2) {
            addCriterion("freeFreight not between", value1, value2, "freefreight");
            return (Criteria) this;
        }

        public Criteria andAmountmoneyIsNull() {
            addCriterion("amountMoney is null");
            return (Criteria) this;
        }

        public Criteria andAmountmoneyIsNotNull() {
            addCriterion("amountMoney is not null");
            return (Criteria) this;
        }

        public Criteria andAmountmoneyEqualTo(Integer value) {
            addCriterion("amountMoney =", value, "amountmoney");
            return (Criteria) this;
        }

        public Criteria andAmountmoneyNotEqualTo(Integer value) {
            addCriterion("amountMoney <>", value, "amountmoney");
            return (Criteria) this;
        }

        public Criteria andAmountmoneyGreaterThan(Integer value) {
            addCriterion("amountMoney >", value, "amountmoney");
            return (Criteria) this;
        }

        public Criteria andAmountmoneyGreaterThanOrEqualTo(Integer value) {
            addCriterion("amountMoney >=", value, "amountmoney");
            return (Criteria) this;
        }

        public Criteria andAmountmoneyLessThan(Integer value) {
            addCriterion("amountMoney <", value, "amountmoney");
            return (Criteria) this;
        }

        public Criteria andAmountmoneyLessThanOrEqualTo(Integer value) {
            addCriterion("amountMoney <=", value, "amountmoney");
            return (Criteria) this;
        }

        public Criteria andAmountmoneyIn(List<Integer> values) {
            addCriterion("amountMoney in", values, "amountmoney");
            return (Criteria) this;
        }

        public Criteria andAmountmoneyNotIn(List<Integer> values) {
            addCriterion("amountMoney not in", values, "amountmoney");
            return (Criteria) this;
        }

        public Criteria andAmountmoneyBetween(Integer value1, Integer value2) {
            addCriterion("amountMoney between", value1, value2, "amountmoney");
            return (Criteria) this;
        }

        public Criteria andAmountmoneyNotBetween(Integer value1, Integer value2) {
            addCriterion("amountMoney not between", value1, value2, "amountmoney");
            return (Criteria) this;
        }

        public Criteria andPaytypeIsNull() {
            addCriterion("payType is null");
            return (Criteria) this;
        }

        public Criteria andPaytypeIsNotNull() {
            addCriterion("payType is not null");
            return (Criteria) this;
        }

        public Criteria andPaytypeEqualTo(Integer value) {
            addCriterion("payType =", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotEqualTo(Integer value) {
            addCriterion("payType <>", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeGreaterThan(Integer value) {
            addCriterion("payType >", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("payType >=", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLessThan(Integer value) {
            addCriterion("payType <", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLessThanOrEqualTo(Integer value) {
            addCriterion("payType <=", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeIn(List<Integer> values) {
            addCriterion("payType in", values, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotIn(List<Integer> values) {
            addCriterion("payType not in", values, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeBetween(Integer value1, Integer value2) {
            addCriterion("payType between", value1, value2, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotBetween(Integer value1, Integer value2) {
            addCriterion("payType not between", value1, value2, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaymoneyIsNull() {
            addCriterion("payMoney is null");
            return (Criteria) this;
        }

        public Criteria andPaymoneyIsNotNull() {
            addCriterion("payMoney is not null");
            return (Criteria) this;
        }

        public Criteria andPaymoneyEqualTo(Integer value) {
            addCriterion("payMoney =", value, "paymoney");
            return (Criteria) this;
        }

        public Criteria andPaymoneyNotEqualTo(Integer value) {
            addCriterion("payMoney <>", value, "paymoney");
            return (Criteria) this;
        }

        public Criteria andPaymoneyGreaterThan(Integer value) {
            addCriterion("payMoney >", value, "paymoney");
            return (Criteria) this;
        }

        public Criteria andPaymoneyGreaterThanOrEqualTo(Integer value) {
            addCriterion("payMoney >=", value, "paymoney");
            return (Criteria) this;
        }

        public Criteria andPaymoneyLessThan(Integer value) {
            addCriterion("payMoney <", value, "paymoney");
            return (Criteria) this;
        }

        public Criteria andPaymoneyLessThanOrEqualTo(Integer value) {
            addCriterion("payMoney <=", value, "paymoney");
            return (Criteria) this;
        }

        public Criteria andPaymoneyIn(List<Integer> values) {
            addCriterion("payMoney in", values, "paymoney");
            return (Criteria) this;
        }

        public Criteria andPaymoneyNotIn(List<Integer> values) {
            addCriterion("payMoney not in", values, "paymoney");
            return (Criteria) this;
        }

        public Criteria andPaymoneyBetween(Integer value1, Integer value2) {
            addCriterion("payMoney between", value1, value2, "paymoney");
            return (Criteria) this;
        }

        public Criteria andPaymoneyNotBetween(Integer value1, Integer value2) {
            addCriterion("payMoney not between", value1, value2, "paymoney");
            return (Criteria) this;
        }

        public Criteria andPaystatusIsNull() {
            addCriterion("payStatus is null");
            return (Criteria) this;
        }

        public Criteria andPaystatusIsNotNull() {
            addCriterion("payStatus is not null");
            return (Criteria) this;
        }

        public Criteria andPaystatusEqualTo(Integer value) {
            addCriterion("payStatus =", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotEqualTo(Integer value) {
            addCriterion("payStatus <>", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusGreaterThan(Integer value) {
            addCriterion("payStatus >", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("payStatus >=", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusLessThan(Integer value) {
            addCriterion("payStatus <", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusLessThanOrEqualTo(Integer value) {
            addCriterion("payStatus <=", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusIn(List<Integer> values) {
            addCriterion("payStatus in", values, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotIn(List<Integer> values) {
            addCriterion("payStatus not in", values, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusBetween(Integer value1, Integer value2) {
            addCriterion("payStatus between", value1, value2, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotBetween(Integer value1, Integer value2) {
            addCriterion("payStatus not between", value1, value2, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaytimeIsNull() {
            addCriterion("payTime is null");
            return (Criteria) this;
        }

        public Criteria andPaytimeIsNotNull() {
            addCriterion("payTime is not null");
            return (Criteria) this;
        }

        public Criteria andPaytimeEqualTo(Date value) {
            addCriterion("payTime =", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotEqualTo(Date value) {
            addCriterion("payTime <>", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeGreaterThan(Date value) {
            addCriterion("payTime >", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeGreaterThanOrEqualTo(Date value) {
            addCriterion("payTime >=", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeLessThan(Date value) {
            addCriterion("payTime <", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeLessThanOrEqualTo(Date value) {
            addCriterion("payTime <=", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeIn(List<Date> values) {
            addCriterion("payTime in", values, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotIn(List<Date> values) {
            addCriterion("payTime not in", values, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeBetween(Date value1, Date value2) {
            addCriterion("payTime between", value1, value2, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotBetween(Date value1, Date value2) {
            addCriterion("payTime not between", value1, value2, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaydocumentIsNull() {
            addCriterion("payDocument is null");
            return (Criteria) this;
        }

        public Criteria andPaydocumentIsNotNull() {
            addCriterion("payDocument is not null");
            return (Criteria) this;
        }

        public Criteria andPaydocumentEqualTo(String value) {
            addCriterion("payDocument =", value, "paydocument");
            return (Criteria) this;
        }

        public Criteria andPaydocumentNotEqualTo(String value) {
            addCriterion("payDocument <>", value, "paydocument");
            return (Criteria) this;
        }

        public Criteria andPaydocumentGreaterThan(String value) {
            addCriterion("payDocument >", value, "paydocument");
            return (Criteria) this;
        }

        public Criteria andPaydocumentGreaterThanOrEqualTo(String value) {
            addCriterion("payDocument >=", value, "paydocument");
            return (Criteria) this;
        }

        public Criteria andPaydocumentLessThan(String value) {
            addCriterion("payDocument <", value, "paydocument");
            return (Criteria) this;
        }

        public Criteria andPaydocumentLessThanOrEqualTo(String value) {
            addCriterion("payDocument <=", value, "paydocument");
            return (Criteria) this;
        }

        public Criteria andPaydocumentLike(String value) {
            addCriterion("payDocument like", value, "paydocument");
            return (Criteria) this;
        }

        public Criteria andPaydocumentNotLike(String value) {
            addCriterion("payDocument not like", value, "paydocument");
            return (Criteria) this;
        }

        public Criteria andPaydocumentIn(List<String> values) {
            addCriterion("payDocument in", values, "paydocument");
            return (Criteria) this;
        }

        public Criteria andPaydocumentNotIn(List<String> values) {
            addCriterion("payDocument not in", values, "paydocument");
            return (Criteria) this;
        }

        public Criteria andPaydocumentBetween(String value1, String value2) {
            addCriterion("payDocument between", value1, value2, "paydocument");
            return (Criteria) this;
        }

        public Criteria andPaydocumentNotBetween(String value1, String value2) {
            addCriterion("payDocument not between", value1, value2, "paydocument");
            return (Criteria) this;
        }

        public Criteria andMchidIsNull() {
            addCriterion("mchId is null");
            return (Criteria) this;
        }

        public Criteria andMchidIsNotNull() {
            addCriterion("mchId is not null");
            return (Criteria) this;
        }

        public Criteria andMchidEqualTo(String value) {
            addCriterion("mchId =", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidNotEqualTo(String value) {
            addCriterion("mchId <>", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidGreaterThan(String value) {
            addCriterion("mchId >", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidGreaterThanOrEqualTo(String value) {
            addCriterion("mchId >=", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidLessThan(String value) {
            addCriterion("mchId <", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidLessThanOrEqualTo(String value) {
            addCriterion("mchId <=", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidLike(String value) {
            addCriterion("mchId like", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidNotLike(String value) {
            addCriterion("mchId not like", value, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidIn(List<String> values) {
            addCriterion("mchId in", values, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidNotIn(List<String> values) {
            addCriterion("mchId not in", values, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidBetween(String value1, String value2) {
            addCriterion("mchId between", value1, value2, "mchid");
            return (Criteria) this;
        }

        public Criteria andMchidNotBetween(String value1, String value2) {
            addCriterion("mchId not between", value1, value2, "mchid");
            return (Criteria) this;
        }

        public Criteria andTradenoIsNull() {
            addCriterion("tradeNo is null");
            return (Criteria) this;
        }

        public Criteria andTradenoIsNotNull() {
            addCriterion("tradeNo is not null");
            return (Criteria) this;
        }

        public Criteria andTradenoEqualTo(String value) {
            addCriterion("tradeNo =", value, "tradeno");
            return (Criteria) this;
        }

        public Criteria andTradenoNotEqualTo(String value) {
            addCriterion("tradeNo <>", value, "tradeno");
            return (Criteria) this;
        }

        public Criteria andTradenoGreaterThan(String value) {
            addCriterion("tradeNo >", value, "tradeno");
            return (Criteria) this;
        }

        public Criteria andTradenoGreaterThanOrEqualTo(String value) {
            addCriterion("tradeNo >=", value, "tradeno");
            return (Criteria) this;
        }

        public Criteria andTradenoLessThan(String value) {
            addCriterion("tradeNo <", value, "tradeno");
            return (Criteria) this;
        }

        public Criteria andTradenoLessThanOrEqualTo(String value) {
            addCriterion("tradeNo <=", value, "tradeno");
            return (Criteria) this;
        }

        public Criteria andTradenoLike(String value) {
            addCriterion("tradeNo like", value, "tradeno");
            return (Criteria) this;
        }

        public Criteria andTradenoNotLike(String value) {
            addCriterion("tradeNo not like", value, "tradeno");
            return (Criteria) this;
        }

        public Criteria andTradenoIn(List<String> values) {
            addCriterion("tradeNo in", values, "tradeno");
            return (Criteria) this;
        }

        public Criteria andTradenoNotIn(List<String> values) {
            addCriterion("tradeNo not in", values, "tradeno");
            return (Criteria) this;
        }

        public Criteria andTradenoBetween(String value1, String value2) {
            addCriterion("tradeNo between", value1, value2, "tradeno");
            return (Criteria) this;
        }

        public Criteria andTradenoNotBetween(String value1, String value2) {
            addCriterion("tradeNo not between", value1, value2, "tradeno");
            return (Criteria) this;
        }

        public Criteria andUseintegraltotalIsNull() {
            addCriterion("useIntegralTotal is null");
            return (Criteria) this;
        }

        public Criteria andUseintegraltotalIsNotNull() {
            addCriterion("useIntegralTotal is not null");
            return (Criteria) this;
        }

        public Criteria andUseintegraltotalEqualTo(Integer value) {
            addCriterion("useIntegralTotal =", value, "useintegraltotal");
            return (Criteria) this;
        }

        public Criteria andUseintegraltotalNotEqualTo(Integer value) {
            addCriterion("useIntegralTotal <>", value, "useintegraltotal");
            return (Criteria) this;
        }

        public Criteria andUseintegraltotalGreaterThan(Integer value) {
            addCriterion("useIntegralTotal >", value, "useintegraltotal");
            return (Criteria) this;
        }

        public Criteria andUseintegraltotalGreaterThanOrEqualTo(Integer value) {
            addCriterion("useIntegralTotal >=", value, "useintegraltotal");
            return (Criteria) this;
        }

        public Criteria andUseintegraltotalLessThan(Integer value) {
            addCriterion("useIntegralTotal <", value, "useintegraltotal");
            return (Criteria) this;
        }

        public Criteria andUseintegraltotalLessThanOrEqualTo(Integer value) {
            addCriterion("useIntegralTotal <=", value, "useintegraltotal");
            return (Criteria) this;
        }

        public Criteria andUseintegraltotalIn(List<Integer> values) {
            addCriterion("useIntegralTotal in", values, "useintegraltotal");
            return (Criteria) this;
        }

        public Criteria andUseintegraltotalNotIn(List<Integer> values) {
            addCriterion("useIntegralTotal not in", values, "useintegraltotal");
            return (Criteria) this;
        }

        public Criteria andUseintegraltotalBetween(Integer value1, Integer value2) {
            addCriterion("useIntegralTotal between", value1, value2, "useintegraltotal");
            return (Criteria) this;
        }

        public Criteria andUseintegraltotalNotBetween(Integer value1, Integer value2) {
            addCriterion("useIntegralTotal not between", value1, value2, "useintegraltotal");
            return (Criteria) this;
        }

        public Criteria andUsebalancetotalIsNull() {
            addCriterion("useBalanceTotal is null");
            return (Criteria) this;
        }

        public Criteria andUsebalancetotalIsNotNull() {
            addCriterion("useBalanceTotal is not null");
            return (Criteria) this;
        }

        public Criteria andUsebalancetotalEqualTo(Integer value) {
            addCriterion("useBalanceTotal =", value, "usebalancetotal");
            return (Criteria) this;
        }

        public Criteria andUsebalancetotalNotEqualTo(Integer value) {
            addCriterion("useBalanceTotal <>", value, "usebalancetotal");
            return (Criteria) this;
        }

        public Criteria andUsebalancetotalGreaterThan(Integer value) {
            addCriterion("useBalanceTotal >", value, "usebalancetotal");
            return (Criteria) this;
        }

        public Criteria andUsebalancetotalGreaterThanOrEqualTo(Integer value) {
            addCriterion("useBalanceTotal >=", value, "usebalancetotal");
            return (Criteria) this;
        }

        public Criteria andUsebalancetotalLessThan(Integer value) {
            addCriterion("useBalanceTotal <", value, "usebalancetotal");
            return (Criteria) this;
        }

        public Criteria andUsebalancetotalLessThanOrEqualTo(Integer value) {
            addCriterion("useBalanceTotal <=", value, "usebalancetotal");
            return (Criteria) this;
        }

        public Criteria andUsebalancetotalIn(List<Integer> values) {
            addCriterion("useBalanceTotal in", values, "usebalancetotal");
            return (Criteria) this;
        }

        public Criteria andUsebalancetotalNotIn(List<Integer> values) {
            addCriterion("useBalanceTotal not in", values, "usebalancetotal");
            return (Criteria) this;
        }

        public Criteria andUsebalancetotalBetween(Integer value1, Integer value2) {
            addCriterion("useBalanceTotal between", value1, value2, "usebalancetotal");
            return (Criteria) this;
        }

        public Criteria andUsebalancetotalNotBetween(Integer value1, Integer value2) {
            addCriterion("useBalanceTotal not between", value1, value2, "usebalancetotal");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("updateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("updateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterion("updateTime =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterion("updateTime <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterion("updateTime >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("updateTime >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterion("updateTime <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterion("updateTime <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterion("updateTime in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterion("updateTime not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterion("updateTime between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterion("updateTime not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeIsNull() {
            addCriterion("logisticsCode is null");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeIsNotNull() {
            addCriterion("logisticsCode is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeEqualTo(String value) {
            addCriterion("logisticsCode =", value, "logisticscode");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeNotEqualTo(String value) {
            addCriterion("logisticsCode <>", value, "logisticscode");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeGreaterThan(String value) {
            addCriterion("logisticsCode >", value, "logisticscode");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeGreaterThanOrEqualTo(String value) {
            addCriterion("logisticsCode >=", value, "logisticscode");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeLessThan(String value) {
            addCriterion("logisticsCode <", value, "logisticscode");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeLessThanOrEqualTo(String value) {
            addCriterion("logisticsCode <=", value, "logisticscode");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeLike(String value) {
            addCriterion("logisticsCode like", value, "logisticscode");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeNotLike(String value) {
            addCriterion("logisticsCode not like", value, "logisticscode");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeIn(List<String> values) {
            addCriterion("logisticsCode in", values, "logisticscode");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeNotIn(List<String> values) {
            addCriterion("logisticsCode not in", values, "logisticscode");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeBetween(String value1, String value2) {
            addCriterion("logisticsCode between", value1, value2, "logisticscode");
            return (Criteria) this;
        }

        public Criteria andLogisticscodeNotBetween(String value1, String value2) {
            addCriterion("logisticsCode not between", value1, value2, "logisticscode");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoIsNull() {
            addCriterion("logisticsNo is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoIsNotNull() {
            addCriterion("logisticsNo is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoEqualTo(String value) {
            addCriterion("logisticsNo =", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoNotEqualTo(String value) {
            addCriterion("logisticsNo <>", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoGreaterThan(String value) {
            addCriterion("logisticsNo >", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoGreaterThanOrEqualTo(String value) {
            addCriterion("logisticsNo >=", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoLessThan(String value) {
            addCriterion("logisticsNo <", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoLessThanOrEqualTo(String value) {
            addCriterion("logisticsNo <=", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoLike(String value) {
            addCriterion("logisticsNo like", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoNotLike(String value) {
            addCriterion("logisticsNo not like", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoIn(List<String> values) {
            addCriterion("logisticsNo in", values, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoNotIn(List<String> values) {
            addCriterion("logisticsNo not in", values, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoBetween(String value1, String value2) {
            addCriterion("logisticsNo between", value1, value2, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoNotBetween(String value1, String value2) {
            addCriterion("logisticsNo not between", value1, value2, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameIsNull() {
            addCriterion("logisticsName is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameIsNotNull() {
            addCriterion("logisticsName is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameEqualTo(String value) {
            addCriterion("logisticsName =", value, "logisticsname");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameNotEqualTo(String value) {
            addCriterion("logisticsName <>", value, "logisticsname");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameGreaterThan(String value) {
            addCriterion("logisticsName >", value, "logisticsname");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameGreaterThanOrEqualTo(String value) {
            addCriterion("logisticsName >=", value, "logisticsname");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameLessThan(String value) {
            addCriterion("logisticsName <", value, "logisticsname");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameLessThanOrEqualTo(String value) {
            addCriterion("logisticsName <=", value, "logisticsname");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameLike(String value) {
            addCriterion("logisticsName like", value, "logisticsname");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameNotLike(String value) {
            addCriterion("logisticsName not like", value, "logisticsname");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameIn(List<String> values) {
            addCriterion("logisticsName in", values, "logisticsname");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameNotIn(List<String> values) {
            addCriterion("logisticsName not in", values, "logisticsname");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameBetween(String value1, String value2) {
            addCriterion("logisticsName between", value1, value2, "logisticsname");
            return (Criteria) this;
        }

        public Criteria andLogisticsnameNotBetween(String value1, String value2) {
            addCriterion("logisticsName not between", value1, value2, "logisticsname");
            return (Criteria) this;
        }

        public Criteria andAddressidIsNull() {
            addCriterion("addressId is null");
            return (Criteria) this;
        }

        public Criteria andAddressidIsNotNull() {
            addCriterion("addressId is not null");
            return (Criteria) this;
        }

        public Criteria andAddressidEqualTo(String value) {
            addCriterion("addressId =", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidNotEqualTo(String value) {
            addCriterion("addressId <>", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidGreaterThan(String value) {
            addCriterion("addressId >", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidGreaterThanOrEqualTo(String value) {
            addCriterion("addressId >=", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidLessThan(String value) {
            addCriterion("addressId <", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidLessThanOrEqualTo(String value) {
            addCriterion("addressId <=", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidLike(String value) {
            addCriterion("addressId like", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidNotLike(String value) {
            addCriterion("addressId not like", value, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidIn(List<String> values) {
            addCriterion("addressId in", values, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidNotIn(List<String> values) {
            addCriterion("addressId not in", values, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidBetween(String value1, String value2) {
            addCriterion("addressId between", value1, value2, "addressid");
            return (Criteria) this;
        }

        public Criteria andAddressidNotBetween(String value1, String value2) {
            addCriterion("addressId not between", value1, value2, "addressid");
            return (Criteria) this;
        }

        public Criteria andCouponidIsNull() {
            addCriterion("couponId is null");
            return (Criteria) this;
        }

        public Criteria andCouponidIsNotNull() {
            addCriterion("couponId is not null");
            return (Criteria) this;
        }

        public Criteria andCouponidEqualTo(String value) {
            addCriterion("couponId =", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidNotEqualTo(String value) {
            addCriterion("couponId <>", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidGreaterThan(String value) {
            addCriterion("couponId >", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidGreaterThanOrEqualTo(String value) {
            addCriterion("couponId >=", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidLessThan(String value) {
            addCriterion("couponId <", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidLessThanOrEqualTo(String value) {
            addCriterion("couponId <=", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidLike(String value) {
            addCriterion("couponId like", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidNotLike(String value) {
            addCriterion("couponId not like", value, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidIn(List<String> values) {
            addCriterion("couponId in", values, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidNotIn(List<String> values) {
            addCriterion("couponId not in", values, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidBetween(String value1, String value2) {
            addCriterion("couponId between", value1, value2, "couponid");
            return (Criteria) this;
        }

        public Criteria andCouponidNotBetween(String value1, String value2) {
            addCriterion("couponId not between", value1, value2, "couponid");
            return (Criteria) this;
        }

        public Criteria andAllrefundIsNull() {
            addCriterion("allRefund is null");
            return (Criteria) this;
        }

        public Criteria andAllrefundIsNotNull() {
            addCriterion("allRefund is not null");
            return (Criteria) this;
        }

        public Criteria andAllrefundEqualTo(Integer value) {
            addCriterion("allRefund =", value, "allrefund");
            return (Criteria) this;
        }

        public Criteria andAllrefundNotEqualTo(Integer value) {
            addCriterion("allRefund <>", value, "allrefund");
            return (Criteria) this;
        }

        public Criteria andAllrefundGreaterThan(Integer value) {
            addCriterion("allRefund >", value, "allrefund");
            return (Criteria) this;
        }

        public Criteria andAllrefundGreaterThanOrEqualTo(Integer value) {
            addCriterion("allRefund >=", value, "allrefund");
            return (Criteria) this;
        }

        public Criteria andAllrefundLessThan(Integer value) {
            addCriterion("allRefund <", value, "allrefund");
            return (Criteria) this;
        }

        public Criteria andAllrefundLessThanOrEqualTo(Integer value) {
            addCriterion("allRefund <=", value, "allrefund");
            return (Criteria) this;
        }

        public Criteria andAllrefundIn(List<Integer> values) {
            addCriterion("allRefund in", values, "allrefund");
            return (Criteria) this;
        }

        public Criteria andAllrefundNotIn(List<Integer> values) {
            addCriterion("allRefund not in", values, "allrefund");
            return (Criteria) this;
        }

        public Criteria andAllrefundBetween(Integer value1, Integer value2) {
            addCriterion("allRefund between", value1, value2, "allrefund");
            return (Criteria) this;
        }

        public Criteria andAllrefundNotBetween(Integer value1, Integer value2) {
            addCriterion("allRefund not between", value1, value2, "allrefund");
            return (Criteria) this;
        }

        public Criteria andAllcommentIsNull() {
            addCriterion("allComment is null");
            return (Criteria) this;
        }

        public Criteria andAllcommentIsNotNull() {
            addCriterion("allComment is not null");
            return (Criteria) this;
        }

        public Criteria andAllcommentEqualTo(Integer value) {
            addCriterion("allComment =", value, "allcomment");
            return (Criteria) this;
        }

        public Criteria andAllcommentNotEqualTo(Integer value) {
            addCriterion("allComment <>", value, "allcomment");
            return (Criteria) this;
        }

        public Criteria andAllcommentGreaterThan(Integer value) {
            addCriterion("allComment >", value, "allcomment");
            return (Criteria) this;
        }

        public Criteria andAllcommentGreaterThanOrEqualTo(Integer value) {
            addCriterion("allComment >=", value, "allcomment");
            return (Criteria) this;
        }

        public Criteria andAllcommentLessThan(Integer value) {
            addCriterion("allComment <", value, "allcomment");
            return (Criteria) this;
        }

        public Criteria andAllcommentLessThanOrEqualTo(Integer value) {
            addCriterion("allComment <=", value, "allcomment");
            return (Criteria) this;
        }

        public Criteria andAllcommentIn(List<Integer> values) {
            addCriterion("allComment in", values, "allcomment");
            return (Criteria) this;
        }

        public Criteria andAllcommentNotIn(List<Integer> values) {
            addCriterion("allComment not in", values, "allcomment");
            return (Criteria) this;
        }

        public Criteria andAllcommentBetween(Integer value1, Integer value2) {
            addCriterion("allComment between", value1, value2, "allcomment");
            return (Criteria) this;
        }

        public Criteria andAllcommentNotBetween(Integer value1, Integer value2) {
            addCriterion("allComment not between", value1, value2, "allcomment");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusIsNull() {
            addCriterion("logisticsStatus is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusIsNotNull() {
            addCriterion("logisticsStatus is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusEqualTo(String value) {
            addCriterion("logisticsStatus =", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusNotEqualTo(String value) {
            addCriterion("logisticsStatus <>", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusGreaterThan(String value) {
            addCriterion("logisticsStatus >", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusGreaterThanOrEqualTo(String value) {
            addCriterion("logisticsStatus >=", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusLessThan(String value) {
            addCriterion("logisticsStatus <", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusLessThanOrEqualTo(String value) {
            addCriterion("logisticsStatus <=", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusLike(String value) {
            addCriterion("logisticsStatus like", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusNotLike(String value) {
            addCriterion("logisticsStatus not like", value, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusIn(List<String> values) {
            addCriterion("logisticsStatus in", values, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusNotIn(List<String> values) {
            addCriterion("logisticsStatus not in", values, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusBetween(String value1, String value2) {
            addCriterion("logisticsStatus between", value1, value2, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andLogisticsstatusNotBetween(String value1, String value2) {
            addCriterion("logisticsStatus not between", value1, value2, "logisticsstatus");
            return (Criteria) this;
        }

        public Criteria andProxyidIsNull() {
            addCriterion("proxyId is null");
            return (Criteria) this;
        }

        public Criteria andProxyidIsNotNull() {
            addCriterion("proxyId is not null");
            return (Criteria) this;
        }

        public Criteria andProxyidEqualTo(String value) {
            addCriterion("proxyId =", value, "proxyid");
            return (Criteria) this;
        }

        public Criteria andProxyidNotEqualTo(String value) {
            addCriterion("proxyId <>", value, "proxyid");
            return (Criteria) this;
        }

        public Criteria andProxyidGreaterThan(String value) {
            addCriterion("proxyId >", value, "proxyid");
            return (Criteria) this;
        }

        public Criteria andProxyidGreaterThanOrEqualTo(String value) {
            addCriterion("proxyId >=", value, "proxyid");
            return (Criteria) this;
        }

        public Criteria andProxyidLessThan(String value) {
            addCriterion("proxyId <", value, "proxyid");
            return (Criteria) this;
        }

        public Criteria andProxyidLessThanOrEqualTo(String value) {
            addCriterion("proxyId <=", value, "proxyid");
            return (Criteria) this;
        }

        public Criteria andProxyidLike(String value) {
            addCriterion("proxyId like", value, "proxyid");
            return (Criteria) this;
        }

        public Criteria andProxyidNotLike(String value) {
            addCriterion("proxyId not like", value, "proxyid");
            return (Criteria) this;
        }

        public Criteria andProxyidIn(List<String> values) {
            addCriterion("proxyId in", values, "proxyid");
            return (Criteria) this;
        }

        public Criteria andProxyidNotIn(List<String> values) {
            addCriterion("proxyId not in", values, "proxyid");
            return (Criteria) this;
        }

        public Criteria andProxyidBetween(String value1, String value2) {
            addCriterion("proxyId between", value1, value2, "proxyid");
            return (Criteria) this;
        }

        public Criteria andProxyidNotBetween(String value1, String value2) {
            addCriterion("proxyId not between", value1, value2, "proxyid");
            return (Criteria) this;
        }

        public Criteria andShareidIsNull() {
            addCriterion("shareId is null");
            return (Criteria) this;
        }

        public Criteria andShareidIsNotNull() {
            addCriterion("shareId is not null");
            return (Criteria) this;
        }

        public Criteria andShareidEqualTo(String value) {
            addCriterion("shareId =", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidNotEqualTo(String value) {
            addCriterion("shareId <>", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidGreaterThan(String value) {
            addCriterion("shareId >", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidGreaterThanOrEqualTo(String value) {
            addCriterion("shareId >=", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidLessThan(String value) {
            addCriterion("shareId <", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidLessThanOrEqualTo(String value) {
            addCriterion("shareId <=", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidLike(String value) {
            addCriterion("shareId like", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidNotLike(String value) {
            addCriterion("shareId not like", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidIn(List<String> values) {
            addCriterion("shareId in", values, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidNotIn(List<String> values) {
            addCriterion("shareId not in", values, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidBetween(String value1, String value2) {
            addCriterion("shareId between", value1, value2, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidNotBetween(String value1, String value2) {
            addCriterion("shareId not between", value1, value2, "shareid");
            return (Criteria) this;
        }

        public Criteria andSharecommissionIsNull() {
            addCriterion("shareCommission is null");
            return (Criteria) this;
        }

        public Criteria andSharecommissionIsNotNull() {
            addCriterion("shareCommission is not null");
            return (Criteria) this;
        }

        public Criteria andSharecommissionEqualTo(Integer value) {
            addCriterion("shareCommission =", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionNotEqualTo(Integer value) {
            addCriterion("shareCommission <>", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionGreaterThan(Integer value) {
            addCriterion("shareCommission >", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionGreaterThanOrEqualTo(Integer value) {
            addCriterion("shareCommission >=", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionLessThan(Integer value) {
            addCriterion("shareCommission <", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionLessThanOrEqualTo(Integer value) {
            addCriterion("shareCommission <=", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionIn(List<Integer> values) {
            addCriterion("shareCommission in", values, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionNotIn(List<Integer> values) {
            addCriterion("shareCommission not in", values, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionBetween(Integer value1, Integer value2) {
            addCriterion("shareCommission between", value1, value2, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionNotBetween(Integer value1, Integer value2) {
            addCriterion("shareCommission not between", value1, value2, "sharecommission");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}